Fehlerbeschreibung: GENESISServer User Error
-Type: Error
RaiseTime: 20.05.2024 01:32:53
ObjectStorage: oxEShop
MethodName: ox.GENESISLite.Server.CQuerySet.OpenQuerySet
Message:
***************************************************
Data Error
---------------------------------------------------
Object: Recordset
Method: mbLoadDataSet
Message:
Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
SQL:
SELECT TOP 100 TbART.ID As ID , CONVERT(nvarchar(max),IsNULL((TbART.KurztextFR), '')) as DQLKurztext, TbART.NewProduct, TbART.SpecialOffer, TbART.Preis, IsNull((select AVG(Rating) FROM TbAUR WHERE (TbART.ID) = (TbAUR.ART_ID) AND (TbAUR.Rating)>0),0) as DQLAUR_AVGRating, TbART.Inventory, TbART.Signal, 0 as Line_Discount, IsNULL((SELECT TOP 1 (TxKAR.ArtNr) FROM TxKAR WHERE (TbART.ID) = (TxKAR.ART_ID) AND ((TxKAR.Kundennummer) = '')),'ZZZZZZZ') as DQLKUN_ArtNr_Sort_ASC, IsNULL((SELECT TOP 1 (TxKAR.ArtNr) FROM TxKAR WHERE (TbART.ID) = (TxKAR.ART_ID) AND ((TxKAR.Kundennummer) = '')),'') as DQLKUN_ArtNr, (TbART.ArtNr) + CASE WHEN (IsNULL((SELECT TOP 1 (TxKAR.ArtNr) FROM TxKAR WHERE (TbART.ID) = (TxKAR.ART_ID) AND ((TxKAR.Kundennummer) = '')),'')) = '' THEN '' ELSE ' ' + char(91) + (IsNULL((SELECT TOP 1 (TxKAR.ArtNr) FROM TxKAR WHERE (TbART.ID) = (TxKAR.ART_ID) AND ((TxKAR.Kundennummer) = '')),'')) + char(93) END + ' - ' + CONVERT(nvarchar(max),IsNULL((TbART.BezFR),'')) as DQLART_WebBez, (SELECT (TcMEH.BezFR) FROM TcMEH WHERE (TbART.MEH_ID) = (TcMEH.ID)) as DQLMEH_Bez, TbART.TYP_ID, TbARC.Feld_A, TbARC.Feld_B, TbARC.Feld_C, TbARC.Feld_D, TbARC.Feld_E, TbARC.Feld_F, TbARC.Feld_G, TbARC.Feld_H, TbARC.Feld_I, TbARC.Feld_J, TbARC.Feld_K, TbARC.Feld_L, TbARC.Feld_M, TbARC.Feld_N, TbARC.Feld_O, TbARC.Feld_P, TbARC.Feld_Q, TbARC.Feld_R, TbARC.Feld_S, TbARC.Feld_T, TbART.ArtNr, (TbART.ArtNr) + CASE WHEN (IsNULL((SELECT TOP 1 (TxKAR.ArtNr) FROM TxKAR WHERE (TbART.ID) = (TxKAR.ART_ID) AND ((TxKAR.Kundennummer) = '')),'')) = '' THEN '' ELSE ' ' + char(91) + (IsNULL((SELECT TOP 1 (TxKAR.ArtNr) FROM TxKAR WHERE (TbART.ID) = (TxKAR.ART_ID) AND ((TxKAR.Kundennummer) = '')),'')) + char(93) END as DQLART_ArtNr, (TbART.BezFR) as DQLART_Bez, IsNULL(TbART.Verzeichnis,'') + '/' + IsNULL((TbART.Bildname), '') as DQLART_Bild, TbART.MinOrderQty, TbART.ArtNrURL_Desc, TbART.KATCodeList, TbART.BezFR as Bez, TbART.HER_IDs, (SELECT (TcMEH.Code) FROM TcMEH WHERE (TbART.MEH_ID) = (TcMEH.ID)) as DQLMEH_Code, TbART.Variante_HeadProduct as HeadProduct, TbART.MultiAME, IsNULL((IsNULL((SELECT TOP 1 (TxKAR.ArtNr) FROM TxKAR WHERE (TbART.ID) = (TxKAR.ART_ID) AND ((TxKAR.Kundennummer) = '')),'')),'') + ' ' + (TbART.SuchbegriffeFR) as DQLSearchKeywords, TbART.TOP_KAT_ID, TbART.GTIN, TbART.VendorItemNo, TbART.MEH_ID, TbART.SalesBlocked, TbART.Preis as UnitPrice, TbART.Bez2FR as Bez2 FROM TbART LEFT JOIN TbARC ON (TbART.ID) = (TbARC.ART_ID) WHERE ( ((TbART.ArtNrURL_Desc = '0107024')) AND ((IsNULL((TbART.Inaktiv),0) = 0))) ORDER BY (TbART.SalesBlocked) DESC, (IsNULL((SELECT TOP 1 (TxKAR.ArtNr) FROM TxKAR WHERE (TbART.ID) = (TxKAR.ART_ID) AND ((TxKAR.Kundennummer) = '')),'ZZZZZZZ')) ASC, (TbART.BezFR)
Additional Info:
SQL: SELECT TOP 100 TbART.ID As ID , CONVERT(nvarchar(max),IsNULL((TbART.KurztextFR), '')) as DQLKurztext, TbART.NewProduct, TbART.SpecialOffer, TbART.Preis, IsNull((select AVG(Rating) FROM TbAUR WHERE (TbART.ID) = (TbAUR.ART_ID) AND (TbAUR.Rating)>0),0) as DQLAUR_AVGRating, TbART.Inventory, TbART.Signal, 0 as Line_Discount, IsNULL((SELECT TOP 1 (TxKAR.ArtNr) FROM TxKAR WHERE (TbART.ID) = (TxKAR.ART_ID) AND ((TxKAR.Kundennummer) = '')),'ZZZZZZZ') as DQLKUN_ArtNr_Sort_ASC, IsNULL((SELECT TOP 1 (TxKAR.ArtNr) FROM TxKAR WHERE (TbART.ID) = (TxKAR.ART_ID) AND ((TxKAR.Kundennummer) = '')),'') as DQLKUN_ArtNr, (TbART.ArtNr) + CASE WHEN (IsNULL((SELECT TOP 1 (TxKAR.ArtNr) FROM TxKAR WHERE (TbART.ID) = (TxKAR.ART_ID) AND ((TxKAR.Kundennummer) = '')),'')) = '' THEN '' ELSE ' ' + char(91) + (IsNULL((SELECT TOP 1 (TxKAR.ArtNr) FROM TxKAR WHERE (TbART.ID) = (TxKAR.ART_ID) AND ((TxKAR.Kundennummer) = '')),'')) + char(93) END + ' - ' + CONVERT(nvarchar(max),IsNULL((TbART.BezFR),'')) as DQLART_WebBez, (SELECT (TcMEH.BezFR) FROM TcMEH WHERE (TbART.MEH_ID) = (TcMEH.ID)) as DQLMEH_Bez, TbART.TYP_ID, TbARC.Feld_A, TbARC.Feld_B, TbARC.Feld_C, TbARC.Feld_D, TbARC.Feld_E, TbARC.Feld_F, TbARC.Feld_G, TbARC.Feld_H, TbARC.Feld_I, TbARC.Feld_J, TbARC.Feld_K, TbARC.Feld_L, TbARC.Feld_M, TbARC.Feld_N, TbARC.Feld_O, TbARC.Feld_P, TbARC.Feld_Q, TbARC.Feld_R, TbARC.Feld_S, TbARC.Feld_T, TbART.ArtNr, (TbART.ArtNr) + CASE WHEN (IsNULL((SELECT TOP 1 (TxKAR.ArtNr) FROM TxKAR WHERE (TbART.ID) = (TxKAR.ART_ID) AND ((TxKAR.Kundennummer) = '')),'')) = '' THEN '' ELSE ' ' + char(91) + (IsNULL((SELECT TOP 1 (TxKAR.ArtNr) FROM TxKAR WHERE (TbART.ID) = (TxKAR.ART_ID) AND ((TxKAR.Kundennummer) = '')),'')) + char(93) END as DQLART_ArtNr, (TbART.BezFR) as DQLART_Bez, IsNULL(TbART.Verzeichnis,'') + '/' + IsNULL((TbART.Bildname), '') as DQLART_Bild, TbART.MinOrderQty, TbART.ArtNrURL_Desc, TbART.KATCodeList, TbART.BezFR as Bez, TbART.HER_IDs, (SELECT (TcMEH.Code) FROM TcMEH WHERE (TbART.MEH_ID) = (TcMEH.ID)) as DQLMEH_Code, TbART.Variante_HeadProduct as HeadProduct, TbART.MultiAME, IsNULL((IsNULL((SELECT TOP 1 (TxKAR.ArtNr) FROM TxKAR WHERE (TbART.ID) = (TxKAR.ART_ID) AND ((TxKAR.Kundennummer) = '')),'')),'') + ' ' + (TbART.SuchbegriffeFR) as DQLSearchKeywords, TbART.TOP_KAT_ID, TbART.GTIN, TbART.VendorItemNo, TbART.MEH_ID, TbART.SalesBlocked, TbART.Preis as UnitPrice, TbART.Bez2FR as Bez2 FROM TbART LEFT JOIN TbARC ON (TbART.ID) = (TbARC.ART_ID) WHERE ( ((TbART.ArtNrURL_Desc = '0107024')) AND ((IsNULL((TbART.Inaktiv),0) = 0))) ORDER BY (TbART.SalesBlocked) DESC, (IsNULL((SELECT TOP 1 (TxKAR.ArtNr) FROM TxKAR WHERE (TbART.ID) = (TxKAR.ART_ID) AND ((TxKAR.Kundennummer) = '')),'ZZZZZZZ')) ASC, (TbART.BezFR)
GENESISServer User Error
-Type: Error
RaiseTime: 20.05.2024 01:32:53
ObjectStorage: oxEShop
MethodName: ox.GENESISLite.Server.CData.GetVDS
Message: Can't load Search DataObject Object for ART(ArtikelListe_Shop) ! Please check prior Error-Messages.
EventLogId:0bea4603-0462-40c2-bfe4-103fc58f6bd4
Error Description:
Error Number: 0
Error Source:
Error LineNo: 0
Error LastDllError: 0
Session-Informationen:
USR.ID: 16998023
Login_KUN.ID: 0
Login_KUN.Kundennummer:
BLUser:
NavisionWebLoginType: 1
LoginName:
WAE.Code: CHF
LNG.Code: FR
Language_ID: 2
Request-Informationen:
Request.RawUrl: /de-product-le28004x_luftentoel_element~0107024
Request.Browser.Id: webkit
Request.Browser.Browser: Mozilla
Request.Browser.IsMobileDevice: False
Request.Browser.EcmaScriptVersion: 3.0
Timestamp: 20.05.2024 01:32:53